About

Column

About

Purpose of Investigation

The purpose of this investigation is to graph each customer’s overall satisfaction based on their business purpose. This is then further broken down by the membership level of each customer.

These graphs can be applied to a real world scenario in which a hotel wishes to gain an insight into the level of satisfaction across its customer base. The hotel would put stress on wanting to know the satisfaction of their most profitable customers (i.e. Platinum membership customers) with a secondary stress on finding the general satisfaction landscape for all customers.

Data Set

The following graphs are created from a data set containing a large amount of satisfaction ratings by customers staying at a hotel. The following fields are in the set:

Field Description
custID The Customer’s ID, used as the primary key (format: ID_* where * is the next sequential number)
satCleanRoom Customer’s satisfaction with their room’s cleanliness (0-7)
satCleanBath Customer’s satisfaction with their bath’s cleanliness (0-7)
satCleanCommon Customer’s satisfaction with the common room’s cleanliness (0-7)
satRoomPrice Customer’s satisfaction with their room price (0-7)
satDiningPrice Customer’s satisfaction with food prices (0-7)
satWifiPrice Customer’s satisfaction with Wi-Fi price (0-7)
satParkingPrice Customer’s satisfaction with parking price (0-7)
satPerks Customer’s satisfaction with membership perks (0-7)
satCity Customer’s satisfaction with the city (0-7)
satCloseTransp Customer’s satisfaction with nearby transport (0-7)
satCloseEvents Customer’s satisfaction with nearby events (0-7)
satPoints Customer’s satisfaction with nearby points of interest (0-7)
satRecognition Customer’s satisfaction with hotel recognition (0-7)
satFrontStaff Customer’s satisfaction with the hotel’s front staff (0-7)
satDiningStaff Customer’s satisfaction with hotel’s dining staff (0-7)
satHouseStaff Customer’s satisfaction with hotel’s house staff (0-7)
satValetStaff Customer’s satisfaction with hotel’s valet staff (0-7)
satOverall Customer’s overall satisfaction (0-7)
distanceTraveled Distance traveled by customer to the hotel (miles rounded to nearest whole no.)
nightsStayed Nights stayed by customer (number)
visitPurpose Purpose of customer’s visit (Business/Concert/Conference/OtherOrMixed/SportsEvent/Vacation)
avgRoomSpendPerNight Average amount spent on the customer’s room per night (Dollars)
avgFoodSpendPerNight Average amount spent on the customer’s food per night (Dollars)
avgWifiSpendPerNight Average amount spent on the customer’s Wi-Fi per night (Dollars)
eliteSegment Customer’s membership level (NoStatus/Silver/Gold/Platinum)

Overall Satisfaction

Column

Chart A

Platinum & Gold

Column

Platinum Satisfaction

Column

Gold Satisfaction

Silver & No-Status

Column

Silver Satisfaction

Column

No-Status Satisfaction